Hello,

I have just installed MS Office 2013 Proffessional Plus. I have also Installed SP1. I am local admin on my computer. When I try to use PowerPivot and load my table into the data model I get the error message "We couldn't load the Data Model. This may be because the Data Model in this workgroup is damaged" 

Any suggestions or help would be highly appreciated.

HiBased on the error message, I recommend you try the following steps if you have not tried:

1. Install the latest update patches, please see the below link, and I copied here:

>>The problem here is a memory conflict between AS in excel in tabular (both want a lot of memory). When AS in Excel doesnt get the memory it wants it fails. We are working on a fix that will resolve this issue in an upcomming update of Office 2013.<<

https://connect.microsoft.com/SQLServer/feedback/details/780949/powerpivot-couldnt-load-data-model-when-ssas-tabular-instance-is-running#details

2. Run Excel 2013 64bit version as admin rights

https://social.technet.microsoft.com/Forums/office/en-US/2baba8c9-822b-4a1e-85a0-2c0cd0147fb1/excel-2013-powerpivot-couldnt-load-the-data-model?forum=officesetupdeploy

3. Add the USER group and allow more permissions

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2013/08/27/powerpivot-for-excel-2013-error-when-opening-the-manage-window-quot-we-couldn-t-load-the-data-model-this-may-be-because-the-data-model-in-this-workgroup-is-damaged-quot.aspx

4. Someone work out this issue to stop the Tabular Model instance.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/caefb322-ca73-4676-9e3f-0af73aed2296/powerpivot-2013-doesnt-work-on-excel-2013-office-365-data-model-issue?forum=sqlkjpowerpivotforexcel

Hope it's helpful.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"